// ******************************************************************
// * Copyright(c)  Dextrys P&G Team
// * Description   : Schema_MST_PRODUCT
// * CreateDate    : 2012/12/27 11:03:51
// * Creater       : MstProductTable
// * LastChangeDate: 2012/12/27 11:03:51
// * LastChanger   : 2012/12/27 11:03:51
// * Version Info  : 1.0 For LKBOOK
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
    [Serializable]
    public partial class MstProductTable : TableInfo
    {
        public const string C_TableName = "MST_PRODUCT";

        public const string C_PRODUCT_ID = "PRODUCT_ID";
        public const string C_PRODUCT_TYPE_ID = "PRODUCT_TYPE_ID";
        public const string C_PRODUCT_CODE = "PRODUCT_CODE";
        public const string C_PRODUCT_SPEC_IN = "PRODUCT_SPEC_IN";
        public const string C_PRODUCT_SPEC_OUT = "PRODUCT_SPEC_OUT";
        public const string C_PRODUCT_NAME = "PRODUCT_NAME";
        public const string C_SUGGEST_PRICE = "SUGGEST_PRICE";
        public const string C_MATERIAL = "MATERIAL";
        public const string C_WEIGHT = "WEIGHT";
        public const string C_SIZE = "SIZE";
        public const string C_DIAMETER_OUT = "DIAMETER_OUT";
        public const string C_DIAMETER_IN = "DIAMETER_IN";
        public const string C_LENGTH = "LENGTH";
        public const string C_UNIT = "UNIT";
        public const string C_MINOR_UNIT = "MINOR_UNIT";
        public const string C_FORMUAL = "FORMUAL";
        public const string C_DESCRIPTION = "DESCRIPTION";
        public const string C_DELETE_FLAG = "DELETE_FLAG";
        public const string C_MATERIAL_CODE = "MATERIAL_CODE";
        public const string C_TYPE_NAME = "TYPE_NAME";
        public const string C_TYPE_CODE = "TYPE_CODE";
        public const string C_STD_NAME = "STD_NAME";
        public const string C_STD_CODE = "STD_CODE";
        public const string C_ROOT_CODE_TYPE = "ROOT_CODE_TYPE";
        public const string C_FLOW_CODE = "FLOW_CODE";

        public MstProductTable()
        {
            _tableName = "MST_PRODUCT";
        }

        protected static MstProductTable _current;
        public static MstProductTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }

        private static void Initial()
        {
            _current = new MstProductTable();

            _current.Add(C_PRODUCT_ID, new ColumnInfo(C_PRODUCT_ID, "ProductId", true, typeof(string)));
            _current.Add(C_PRODUCT_TYPE_ID, new ColumnInfo(C_PRODUCT_TYPE_ID, "ProductTypeId", false, typeof(string)));
            _current.Add(C_PRODUCT_CODE, new ColumnInfo(C_PRODUCT_CODE, "ProductCode", false, typeof(string)));
            _current.Add(C_PRODUCT_SPEC_IN, new ColumnInfo(C_PRODUCT_SPEC_IN, "ProductSpecIn", false, typeof(string)));
            _current.Add(C_PRODUCT_SPEC_OUT, new ColumnInfo(C_PRODUCT_SPEC_OUT, "ProductSpecOut", false, typeof(string)));
            _current.Add(C_PRODUCT_NAME, new ColumnInfo(C_PRODUCT_NAME, "ProductName", false, typeof(string)));
            _current.Add(C_SUGGEST_PRICE, new ColumnInfo(C_SUGGEST_PRICE, "SuggestPrice", false, typeof(decimal)));
            _current.Add(C_MATERIAL, new ColumnInfo(C_MATERIAL, "Material", false, typeof(string)));
            _current.Add(C_WEIGHT, new ColumnInfo(C_WEIGHT, "Weight", false, typeof(decimal)));
            _current.Add(C_SIZE, new ColumnInfo(C_SIZE, "Size", false, typeof(decimal)));
            _current.Add(C_DIAMETER_OUT, new ColumnInfo(C_DIAMETER_OUT, "DiameterOut", false, typeof(decimal)));
            _current.Add(C_DIAMETER_IN, new ColumnInfo(C_DIAMETER_IN, "DiameterIn", false, typeof(decimal)));
            _current.Add(C_LENGTH, new ColumnInfo(C_LENGTH, "Length", false, typeof(decimal)));
            _current.Add(C_UNIT, new ColumnInfo(C_UNIT, "Unit", false, typeof(string)));
            _current.Add(C_MINOR_UNIT, new ColumnInfo(C_MINOR_UNIT, "MinorUnit", false, typeof(string)));
            _current.Add(C_FORMUAL, new ColumnInfo(C_FORMUAL, "Formual", false, typeof(decimal)));
            _current.Add(C_DESCRIPTION, new ColumnInfo(C_DESCRIPTION, "Description", false, typeof(string)));
            _current.Add(C_DELETE_FLAG, new ColumnInfo(C_DELETE_FLAG, "DeleteFlag", false, typeof(int)));
            _current.Add(C_MATERIAL_CODE, new ColumnInfo(C_MATERIAL_CODE, "MaterialCode", false, typeof(string)));
            _current.Add(C_TYPE_NAME, new ColumnInfo(C_TYPE_NAME, "TypeName", false, typeof(string)));
            _current.Add(C_TYPE_CODE, new ColumnInfo(C_TYPE_CODE, "TypeCode", false, typeof(string)));
            _current.Add(C_STD_NAME, new ColumnInfo(C_STD_NAME, "StdName", false, typeof(string)));
            _current.Add(C_STD_CODE, new ColumnInfo(C_STD_CODE, "StdCode", false, typeof(string)));
            _current.Add(C_ROOT_CODE_TYPE, new ColumnInfo(C_ROOT_CODE_TYPE, "RootCodeType", false, typeof(string)));
            _current.Add(C_FLOW_CODE, new ColumnInfo(C_FLOW_CODE, "FlowCode", false, typeof(int)));

        }

        public ColumnInfo PRODUCT_ID
        {
            get { return this[C_PRODUCT_ID]; }
        }

        public ColumnInfo PRODUCT_TYPE_ID
        {
            get { return this[C_PRODUCT_TYPE_ID]; }
        }

        public ColumnInfo PRODUCT_CODE
        {
            get { return this[C_PRODUCT_CODE]; }
        }

        public ColumnInfo PRODUCT_SPEC_IN
        {
            get { return this[C_PRODUCT_SPEC_IN]; }
        }

        public ColumnInfo PRODUCT_SPEC_OUT
        {
            get { return this[C_PRODUCT_SPEC_OUT]; }
        }

        public ColumnInfo PRODUCT_NAME
        {
            get { return this[C_PRODUCT_NAME]; }
        }

        public ColumnInfo SUGGEST_PRICE
        {
            get { return this[C_SUGGEST_PRICE]; }
        }

        public ColumnInfo MATERIAL
        {
            get { return this[C_MATERIAL]; }
        }

        public ColumnInfo WEIGHT
        {
            get { return this[C_WEIGHT]; }
        }

        public ColumnInfo SIZE
        {
            get { return this[C_SIZE]; }
        }

        public ColumnInfo DIAMETER_OUT
        {
            get { return this[C_DIAMETER_OUT]; }
        }

        public ColumnInfo DIAMETER_IN
        {
            get { return this[C_DIAMETER_IN]; }
        }

        public ColumnInfo LENGTH
        {
            get { return this[C_LENGTH]; }
        }

        public ColumnInfo UNIT
        {
            get { return this[C_UNIT]; }
        }

        public ColumnInfo MINOR_UNIT
        {
            get { return this[C_MINOR_UNIT]; }
        }

        public ColumnInfo FORMUAL
        {
            get { return this[C_FORMUAL]; }
        }

        public ColumnInfo DESCRIPTION
        {
            get { return this[C_DESCRIPTION]; }
        }

        public ColumnInfo DELETE_FLAG
        {
            get { return this[C_DELETE_FLAG]; }
        }

        public ColumnInfo MATERIAL_CODE
        {
            get { return this[C_MATERIAL_CODE]; }
        }

        public ColumnInfo TYPE_NAME
        {
            get { return this[C_TYPE_NAME]; }
        }

        public ColumnInfo TYPE_CODE
        {
            get { return this[C_TYPE_CODE]; }
        }

        public ColumnInfo STD_NAME
        {
            get { return this[C_STD_NAME]; }
        }

        public ColumnInfo STD_CODE
        {
            get { return this[C_STD_CODE]; }
        }

        public ColumnInfo ROOT_CODE_TYPE
        {
            get { return this[C_ROOT_CODE_TYPE]; }
        }

        public ColumnInfo FLOW_CODE
        {
            get { return this[C_FLOW_CODE]; }
        }



    }
}

